package com.example.gokchinesefoodmappcdev.dao;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.gokchinesefoodmappcdev.entity.SysOrg;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SysOrgDao extends BaseMapper<SysOrg> {


    @Select("SELECT so.name FROM sys_user su left join sys_org so on su.org_id=so.org_id where su.user_id=#{userId}")
    List<SysOrg> findOrgNameByUserId(Integer userId);

}
